package com.cd.university.db.mapper;

import com.cd.university.db.pojo.Score;
import com.cd.university.db.pojo.ScoreKey;
import com.cd.university.vo.AssessmentVo;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface ScoreMapper {
    int deleteByPrimaryKey(ScoreKey key);

    int insert(Score record);

    int insertSelective(Score record);

    Score selectByPrimaryKey(ScoreKey key);

    int updateByPrimaryKeySelective(Score record);

    int updateByPrimaryKey(Score record);

    /**
     * 查询对应的论文的考核情况
     * @return AssessmentVo集合
     */
    public List<AssessmentVo> searchScoreByPaper();

    /**
     * 查询获奖的考核情况,公用level表
     * @return AssessmentVo集合
     */
    public List<AssessmentVo> searchScoreByAwarded();

    /**
     * 查询专利的考核情况
     * @return AssessmentVo集合
     */
    public List<AssessmentVo> searchScoreByPatent();

    /**
     * 查询等级的考核情况
     * @return AssessmentVo集合
     */
    public List<AssessmentVo> searchScoreByLevel();

    /**
     * 所得所有的考核标准
     * @return 考核标准
     */
    public List<Score> searchAll();

}
